<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: lenovo
  Date: 2018/4/2
  Time: 16:26
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>user list</title>
    <style type="text/css">
        table {
            border: 1px solid #000;
            border-collapse: collapse;
        }

        td, th {
            border: 1px solid #000;
            padding: 10px;
        }
    </style>
</head>
<body>
<table>
    <thead>
    <tr>
        <th>编号</th>
        <th>用户名</th>
        <th>密码</th>
        <th>操作1</th>
        <th>操作2</th>
    </tr>
    </thead>
    <tbody>
        <%
            class User{
                int id;
                String name;
                String password;
                public User(int id, String name, String password) {
                    this.id=id;
                    this.name=name;
                    this.password=password;
                }
            }
            List<User> list=new ArrayList<User>();
            Connection connection=null;
            Statement statement=null;
            ResultSet resultSet=null;
            String sql = "select * from user";
            Class.forName("com.mysql.jdbc.Driver");
            connection= DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                    "root",
                    "121212");
            statement=connection.createStatement();
            resultSet=statement.executeQuery(sql);
            while(resultSet.next()){
                int id=resultSet.getInt(1);
                String name=resultSet.getString(2);
                String password=resultSet.getString(3);
                User user=new User(id,name,password);
                list.add(user);
            }
            resultSet.close();
            statement.close();
            connection.close();
            for (User user:list){
                out.write("<tr><td>" + user.id + "</td><td>" + user.name + "</td><td>" + user.password
                        + "</td><td><a href='userUpdate.jsp?id=" + user.id + "&name="+user.name+"&password="+user.password+"'>更新</a></td><td><a href='userDelete.jsp?id="
                        + user.id + "'>删除</a></td></tr>\n");
            }
        %>
    </tbody>
    <tfoot>

    </tfoot>
</table>

</body>
</html>
